VERSION 5.00
Begin VB.Form frmTest 
   Caption         =   "Test"
   ClientHeight    =   1125
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   3450
   Icon            =   "frmTest.frx":0000
   LinkTopic       =   "Form1"
   ScaleHeight     =   1125
   ScaleWidth      =   3450
   StartUpPosition =   2  'CenterScreen
   Begin VB.TextBox txtMaxCount 
      Height          =   285
      Left            =   1920
      TabIndex        =   2
      Text            =   "0"
      Top             =   120
      Width           =   1215
   End
   Begin VB.CommandButton cmdTestConnect 
      Caption         =   "cmdDbConnect"
      Enabled         =   0   'False
      Height          =   375
      Left            =   1320
      TabIndex        =   1
      Top             =   720
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.CommandButton cmdExtract 
      Caption         =   "Extract"
      Height          =   375
      Left            =   2040
      TabIndex        =   0
      Top             =   720
      Width           =   1335
   End
   Begin VB.Label lblMaxCount 
      AutoSize        =   -1  'True
      Caption         =   "Limit Requests Per File To"
      Height          =   195
      Left            =   120
      TabIndex        =   3
      Top             =   120
      Width           =   1845
   End
End
Attribute VB_Name = "frmTest"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'   Program to
'1) extract data from sql server database
'2) save data to ascii file



Private Sub cmdExtract_Click()
    Dim objTest As clsExtractCancel
    Dim lngSuccess As Long
    
    Set objTest = New clsExtractCancel
    
    lngSuccess = objTest.Extract
    
    MsgBox objTest.GetErrorMessages(lngSuccess), , "Test"
    
    Set objTest = Nothing
    
End Sub

Private Sub cmdTestConnect_Click()

'    Dim blnTest As Boolean
'    Dim rsTest As ADODB.Recordset
'
'''objAdoConn.ConnectString = "Provider=SQLOLEDB.1;Data Source=MSSC05;User ID=sa;Password=;Initial Catalog=pgiz;Persist Security Info=False"
'
'    If objAdoConn Is Nothing Then
'        MsgBox "damn thing;'s not set"
'        Set objAdoConn = New clsAdoConnection
'    End If
'
'    blnTest = objAdoConn.InitConnect
'    If blnTest Then
'        Set rsTest = objAdoConn.OpenRecordset("Select * from dir_funds")
'        If rsTest.RecordCount > 0 Then
'            MsgBox "Yipee!!"
'        Else
'            MsgBox "Uh-oh"
'        End If
'    Else
'        MsgBox "Couldn't connect"
'    End If

End Sub

Private Sub Form_Load()
    frmTest.Height = 1635
    frmTest.Width = 3570
    frmTest.Caption = "Cancel Extract"
    lblMaxCount.Top = 160
    lblMaxCount.Left = 120
    txtMaxCount.Top = 120
    txtMaxCount.Left = 2040
    cmdExtract.Top = 720
    cmdExtract.Left = 2280
    cmdExtract.Height = 375
    cmdExtract.Width = 1095
    cmdExtract.Caption = "Extract"
End Sub
